Pandas Profiling Report

Dataset statistics

Number of variables	54
Number of observations	5527754
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.8 GiB
Average record size in memory	548.3 B

Variable types

Numeric	24
Categorical	30

Alerts

`BoolBridle` has constant value "0"	Constant
`Town` has a high cardinality: 1884 distinct values	High cardinality
`PipeId` is highly overall correlated with `Autonomía_Cataluña`	High correlation
`No_Inspections` is highly overall correlated with `gas_natural`	High correlation
`Probability_rate` is highly overall correlated with `preventive_maintenance_rate` and 5 other fields	High correlation
`preventive_maintenance_rate` is highly overall correlated with `Probability_rate` and 5 other fields	High correlation
`Age_pipe_at_inspection` is highly overall correlated with `YearBuilt`	High correlation
`Average_MonthsLastRev` is highly overall correlated with `MonthsLastRev`	High correlation
`MonthsLastRev` is highly overall correlated with `Average_MonthsLastRev`	High correlation
`relative_risk` is highly overall correlated with `Probability_rate` and 4 other fields	High correlation
`average_severity_pipe` is highly overall correlated with `Probability_rate` and 2 other fields	High correlation
`YearBuilt` is highly overall correlated with `Age_pipe_at_inspection`	High correlation
`Diameter` is highly overall correlated with `Relative_Thickness` and 1 other fields	High correlation
`Length` is highly overall correlated with `NumConnections` and 3 other fields	High correlation
`Pressure` is highly overall correlated with `aspect` and 4 other fields	High correlation
`NumConnections` is highly overall correlated with `Length` and 3 other fields	High correlation
`aspect` is highly overall correlated with `Pressure` and 3 other fields	High correlation
`Relative_Thickness` is highly overall correlated with `Diameter` and 4 other fields	High correlation
`pipe_area` is highly overall correlated with `Length` and 2 other fields	High correlation
`area_connection` is highly overall correlated with `NumConnections`	High correlation
`Diameter2` is highly overall correlated with `Diameter` and 1 other fields	High correlation
`Length2` is highly overall correlated with `Length` and 2 other fields	High correlation
`Pressure2` is highly overall correlated with `Pressure` and 2 other fields	High correlation
`TownCount` is highly overall correlated with `Province` and 2 other fields	High correlation
`No_Incidents` is highly overall correlated with `Probability_rate` and 3 other fields	High correlation
`Incidence` is highly overall correlated with `Probability_rate` and 4 other fields	High correlation
`connection_bool` is highly overall correlated with `Length` and 1 other fields	High correlation
`Severity_low` is highly overall correlated with `Probability_rate` and 2 other fields	High correlation
`gas_natural` is highly overall correlated with `No_Inspections`	High correlation
`Material_Acrylonitrile-Butadiene-Styrene` is highly overall correlated with `Pressure` and 1 other fields	High correlation
`Material_Polyethylene` is highly overall correlated with `Pressure` and 1 other fields	High correlation
`Province` is highly overall correlated with `TownCount` and 10 other fields	High correlation
`Autonomía_Andalucía` is highly overall correlated with `Province`	High correlation
`Autonomía_Aragón` is highly overall correlated with `Province`	High correlation
`Autonomía_Castilla y León` is highly overall correlated with `Province`	High correlation
`Autonomía_Castilla-La Mancha` is highly overall correlated with `Province`	High correlation
`Autonomía_Cataluña` is highly overall correlated with `PipeId` and 1 other fields	High correlation
`Autonomía_Comunidad Valenciana` is highly overall correlated with `Province`	High correlation
`Autonomía_Galicia` is highly overall correlated with `Province`	High correlation
`Autonomía_Madrid (Comunidad de)` is highly overall correlated with `TownCount` and 2 other fields	High correlation
`Autonomía_Rioja (La)` is highly overall correlated with `Province`	High correlation
`Madrid` is highly overall correlated with `TownCount` and 2 other fields	High correlation
`No_Incidents` is highly imbalanced (97.7%)	Imbalance
`Incidence` is highly imbalanced (98.5%)	Imbalance
`NumConnectionsUnder` is highly imbalanced (99.9%)	Imbalance
`Severity_high` is highly imbalanced (99.8%)	Imbalance
`Severity_medium` is highly imbalanced (99.7%)	Imbalance
`Severity_low` is highly imbalanced (98.8%)	Imbalance
`gas_natural` is highly imbalanced (87.1%)	Imbalance
`Material_Acrylonitrile-Butadiene-Styrene` is highly imbalanced (64.1%)	Imbalance
`Material_Copper` is highly imbalanced (97.6%)	Imbalance
`Material_Fiberglass-Reinforced Plastic` is highly imbalanced (86.0%)	Imbalance
`Material_Polyethylene` is highly imbalanced (54.9%)	Imbalance
`Material_Polypropylene` is highly imbalanced (96.7%)	Imbalance
`Autonomía_Andalucía` is highly imbalanced (56.7%)	Imbalance
`Autonomía_Aragón` is highly imbalanced (96.0%)	Imbalance
`Autonomía_Balears (Illes)` is highly imbalanced (98.7%)	Imbalance
`Autonomía_Castilla y León` is highly imbalanced (58.2%)	Imbalance
`Autonomía_Castilla-La Mancha` is highly imbalanced (64.8%)	Imbalance
`Autonomía_Extremadura` is highly imbalanced (98.9%)	Imbalance
`Autonomía_Galicia` is highly imbalanced (64.4%)	Imbalance
`Autonomía_Madrid (Comunidad de)` is highly imbalanced (55.3%)	Imbalance
`Autonomía_Navarra (Comunidad Foral de)` is highly imbalanced (99.8%)	Imbalance
`Autonomía_Rioja (La)` is highly imbalanced (89.4%)	Imbalance
`Madrid` is highly imbalanced (65.8%)	Imbalance
`Probability_rate` is highly skewed (γ1 = 22.60196822)	Skewed
`average_severity_pipe` is highly skewed (γ1 = -27.16596007)	Skewed
`aspect` is highly skewed (γ1 = 1145.0382)	Skewed
`area_connection` is highly skewed (γ1 = 465.9658633)	Skewed
`incidence_area` is highly skewed (γ1 = 451.9992111)	Skewed
`Probability_rate` has 5495997 (99.4%) zeros	Zeros
`preventive_maintenance_rate` has 5495997 (99.4%) zeros	Zeros
`relative_risk` has 5495997 (99.4%) zeros	Zeros
`NumConnections` has 3452531 (62.5%) zeros	Zeros
`area_connection` has 3452531 (62.5%) zeros	Zeros
`incidence_area` has 5519945 (99.9%) zeros	Zeros

Reproduction

Analysis started	2023-02-17 17:51:24.903642
Analysis finished	2023-02-17 18:21:08.942137
Duration	29 minutes and 44.04 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

PipeId
Real number (ℝ)

Distinct	1239294
Distinct (%)	22.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0363602 × 10⁸

Minimum	489616
Maximum	4.5199531 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	489616
5-th percentile	12108374
Q1	1.335693 × 10⁸
median	1.9030265 × 10⁸
Q3	2.9861368 × 10⁸
95-th percentile	3.9845461 × 10⁸
Maximum	4.5199531 × 10⁸
Range	4.5150569 × 10⁸
Interquartile range (IQR)	1.6504437 × 10⁸

Descriptive statistics

Standard deviation	1.1442596 × 10⁸
Coefficient of variation (CV)	0.56191416
Kurtosis	-0.74810132
Mean	2.0363602 × 10⁸
Median Absolute Deviation (MAD)	94305870
Skewness	-0.084886108
Sum	1.1256498 × 10¹⁵
Variance	1.3093301 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
388050077	14	< 0.1%
387643872	14	< 0.1%
387044586	14	< 0.1%
384036391	14	< 0.1%
258601675	14	< 0.1%
294881473	14	< 0.1%
258601692	14	< 0.1%
384036104	14	< 0.1%
307722970	14	< 0.1%
388235914	14	< 0.1%
Other values (1239284)	5527614	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
489616	5	< 0.1%
489645	5	< 0.1%
489780	5	< 0.1%
489790	5	< 0.1%
489792	5	< 0.1%
489793	5	< 0.1%
489981	5	< 0.1%
489982	5	< 0.1%
489996	5	< 0.1%
490308	4	< 0.1%

Value	Count	Frequency (%)
451995309	4	< 0.1%
451995260	4	< 0.1%
451995254	2	< 0.1%
451195406	3	< 0.1%
451195391	4	< 0.1%
451195364	3	< 0.1%
451195284	4	< 0.1%
451194879	4	< 0.1%
451194601	4	< 0.1%
451194531	4	< 0.1%

No_Inspections
Real number (ℝ)

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.8998146

Minimum	1
Maximum	11
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	5
median	5
Q3	5
95-th percentile	6
Maximum	11
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.0456331
Coefficient of variation (CV)	0.21340259
Kurtosis	4.9956389
Mean	4.8998146
Median Absolute Deviation (MAD)	0
Skewness	-0.77505844
Sum	27084970
Variance	1.0933487
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
5	3460902	62.6%
6	1044568	18.9%
4	432360	7.8%
3	272844	4.9%
2	201846	3.7%
1	55048	1.0%
7	27790	0.5%
10	15900	0.3%
8	5834	0.1%
9	5572	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	55048	1.0%
2	201846	3.7%
3	272844	4.9%
4	432360	7.8%
5	3460902	62.6%
6	1044568	18.9%
7	27790	0.5%
8	5834	0.1%
9	5572	0.1%
10	15900	0.3%

Value	Count	Frequency (%)
11	5090	0.1%
10	15900	0.3%
9	5572	0.1%
8	5834	0.1%
7	27790	0.5%
6	1044568	18.9%
5	3460902	62.6%
4	432360	7.8%
3	272844	4.9%
2	201846	3.7%

No_Incidents
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	316.3 MiB

0.0	5495997
1.0	29763
2.0	1888
3.0	94
4.0	12

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	16583262
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	5495997	99.4%
1.0	29763	0.5%
2.0	1888	< 0.1%
3.0	94	< 0.1%
4.0	12	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	5495997	99.4%
1.0	29763	0.5%
2.0	1888	< 0.1%
3.0	94	< 0.1%
4.0	12	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	11023751	66.5%
.	5527754	33.3%
1	29763	0.2%
2	1888	< 0.1%
3	94	< 0.1%
4	12	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11055508	66.7%
Other Punctuation	5527754	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	11023751	99.7%
1	29763	0.3%
2	1888	< 0.1%
3	94	< 0.1%
4	12	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	5527754	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	16583262	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	11023751	66.5%
.	5527754	33.3%
1	29763	0.2%
2	1888	< 0.1%
3	94	< 0.1%
4	12	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16583262	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	11023751	66.5%
.	5527754	33.3%
1	29763	0.2%
2	1888	< 0.1%
3	94	< 0.1%
4	12	< 0.1%

InspectionYear
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2015.5875

Minimum	2010
Maximum	2021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	2010
5-th percentile	2011
Q1	2013
median	2016
Q3	2018
95-th percentile	2020
Maximum	2021
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.9040477
Coefficient of variation (CV)	0.0014407947
Kurtosis	-1.178031
Mean	2015.5875
Median Absolute Deviation (MAD)	2
Skewness	-0.094635294
Sum	1.1141672 × 10¹⁰
Variance	8.4334929
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
2019	599879	10.9%
2017	599289	10.8%
2018	565109	10.2%
2020	561162	10.2%
2016	547594	9.9%
2015	543647	9.8%
2012	534717	9.7%
2014	519545	9.4%
2013	511353	9.3%
2011	461998	8.4%
Other values (2)	83461	1.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2010	82345	1.5%
2011	461998	8.4%
2012	534717	9.7%
2013	511353	9.3%
2014	519545	9.4%
2015	543647	9.8%
2016	547594	9.9%
2017	599289	10.8%
2018	565109	10.2%
2019	599879	10.9%

Value	Count	Frequency (%)
2021	1116	< 0.1%
2020	561162	10.2%
2019	599879	10.9%
2018	565109	10.2%
2017	599289	10.8%
2016	547594	9.9%
2015	543647	9.8%
2014	519545	9.4%
2013	511353	9.3%
2012	534717	9.7%

Probability_rate
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0014160483

Minimum	0
Maximum	1
Zeros	5495997
Zeros (%)	99.4%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.021571967
Coefficient of variation (CV)	15.23392
Kurtosis	715.98345
Mean	0.0014160483
Median Absolute Deviation (MAD)	0
Skewness	22.601968
Sum	7827.5667
Variance	0.00046534977
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	5495997	99.4%
0.2	14326	0.3%
0.1666666667	8905	0.2%
0.3333333333	2631	< 0.1%
0.5	2342	< 0.1%
0.25	1392	< 0.1%
0.4	623	< 0.1%
1	604	< 0.1%
0.1428571429	560	< 0.1%
0.6666666667	135	< 0.1%
Other values (6)	239	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5495997	99.4%
0.1	40	< 0.1%
0.1111111111	27	< 0.1%
0.125	72	< 0.1%
0.1428571429	560	< 0.1%
0.1666666667	8905	0.2%
0.2	14326	0.3%
0.25	1392	< 0.1%
0.2857142857	56	< 0.1%
0.3333333333	2631	< 0.1%

Value	Count	Frequency (%)
1	604	< 0.1%
0.75	4	< 0.1%
0.6666666667	135	< 0.1%
0.6	40	< 0.1%
0.5	2342	< 0.1%
0.4	623	< 0.1%
0.3333333333	2631	< 0.1%
0.2857142857	56	< 0.1%
0.25	1392	< 0.1%
0.2	14326	0.3%

preventive_maintenance_rate
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	44
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0050816641

Minimum	0
Maximum	3
Zeros	5495997
Zeros (%)	99.4%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	3
Range	3
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.074160878
Coefficient of variation (CV)	14.593817
Kurtosis	480.23403
Mean	0.0050816641
Median Absolute Deviation (MAD)	0
Skewness	19.184705
Sum	28090.189
Variance	0.0054998358
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
0	5495997	99.4%
0.76	10024	0.2%
0.6388888889	6955	0.1%
0.72	2965	0.1%
1.222222222	2150	< 0.1%
1.75	2100	< 0.1%
0.68	1337	< 0.1%
0.9375	1082	< 0.1%
0.6111111111	998	< 0.1%
0.5833333333	952	< 0.1%
Other values (34)	3194	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5495997	99.4%
0.38	10	< 0.1%
0.39	30	< 0.1%
0.4197530864	9	< 0.1%
0.4320987654	18	< 0.1%
0.46875	16	< 0.1%
0.484375	56	< 0.1%
0.5102040816	49	< 0.1%
0.5306122449	84	< 0.1%
0.5510204082	427	< 0.1%

Value	Count	Frequency (%)
3	503	< 0.1%
2.666666667	2	< 0.1%
2.5	8	< 0.1%
2.4375	4	< 0.1%
2.222222222	116	< 0.1%
2.04	30	< 0.1%
2	73	< 0.1%
1.92	10	< 0.1%
1.777777778	6	< 0.1%
1.75	2100	< 0.1%

Age_pipe_at_inspection
Real number (ℝ)

Distinct	35
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.934826

Minimum	0
Maximum	34
Zeros	47920
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	7
median	12
Q3	18
95-th percentile	26
Maximum	34
Range	34
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	7.3678502
Coefficient of variation (CV)	0.56961342
Kurtosis	-0.3881397
Mean	12.934826
Median Absolute Deviation (MAD)	5
Skewness	0.42706491
Sum	71500534
Variance	54.285216
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
12	294120	5.3%
11	291642	5.3%
13	285283	5.2%
10	284764	5.2%
14	268982	4.9%
9	268032	4.8%
15	259605	4.7%
8	257124	4.7%
16	240189	4.3%
7	229287	4.1%
Other values (25)	2848726	51.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	47920	0.9%
1	147548	2.7%
2	171216	3.1%
3	189886	3.4%
4	213709	3.9%
5	200408	3.6%
6	225015	4.1%
7	229287	4.1%
8	257124	4.7%
9	268032	4.8%

Value	Count	Frequency (%)
34	10238	0.2%
33	14486	0.3%
32	23193	0.4%
31	28606	0.5%
30	37864	0.7%
29	42874	0.8%
28	55527	1.0%
27	63556	1.1%
26	76875	1.4%
25	84102	1.5%

pipe_inspected_frequently
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

1	4764484
0	763270

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	4764484	86.2%
0	763270	13.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	4764484	86.2%
0	763270	13.8%

Most occurring characters

Value	Count	Frequency (%)
1	4764484	86.2%
0	763270	13.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	4764484	86.2%
0	763270	13.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	4764484	86.2%
0	763270	13.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	4764484	86.2%
0	763270	13.8%

Average_MonthsLastRev
Real number (ℝ)

Distinct	523
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.117873

Minimum	0
Maximum	77.5
Zeros	652
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0
5-th percentile	20
Q1	22.166667
median	23.75
Q3	24
95-th percentile	24.333333
Maximum	77.5
Range	77.5
Interquartile range (IQR)	1.8333333

Descriptive statistics

Standard deviation	2.3128741
Coefficient of variation (CV)	0.10004701
Kurtosis	23.285797
Mean	23.117873
Median Absolute Deviation (MAD)	0.45
Skewness	0.41638573
Sum	1.2778991 × 10⁸
Variance	5.3493865
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24	1790833	32.4%
24.2	406656	7.4%
23.6	305635	5.5%
22	257153	4.7%
23.8	189153	3.4%
23.4	160775	2.9%
23	155075	2.8%
21	110285	2.0%
23.2	109843	2.0%
22.2	102428	1.9%
Other values (513)	1939918	35.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	652	< 0.1%
1	81	< 0.1%
2	117	< 0.1%
3	246	< 0.1%
4	288	< 0.1%
5	358	< 0.1%
6	393	< 0.1%
6.5	16	< 0.1%
7	324	< 0.1%
7.5	28	< 0.1%

Value	Count	Frequency (%)
77.5	1	< 0.1%
76	1	< 0.1%
75	1	< 0.1%
70	2	< 0.1%
69	1	< 0.1%
68.5	2	< 0.1%
67.5	3	< 0.1%
67	4	< 0.1%
66.5	5	< 0.1%
66	49	< 0.1%

MonthsLastRev
Real number (ℝ)

Distinct	40
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.984021

Minimum	0
Maximum	39
Zeros	1019
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0
5-th percentile	17
Q1	23
median	24
Q3	24
95-th percentile	25
Maximum	39
Range	39
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	3.0803019
Coefficient of variation (CV)	0.13401928
Kurtosis	14.248788
Mean	22.984021
Median Absolute Deviation (MAD)	0
Skewness	-2.958186
Sum	1.2705001 × 10⁸
Variance	9.4882598
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
24	2989018	54.1%
23	779716	14.1%
22	481052	8.7%
25	458181	8.3%
21	249683	4.5%
20	79949	1.4%
26	45737	0.8%
18	42390	0.8%
19	42130	0.8%
17	35422	0.6%
Other values (30)	324476	5.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1019	< 0.1%
1	1692	< 0.1%
2	2465	< 0.1%
3	4475	0.1%
4	4877	0.1%
5	8163	0.1%
6	10052	0.2%
7	9855	0.2%
8	10010	0.2%
9	17002	0.3%

Value	Count	Frequency (%)
39	1201	< 0.1%
38	446	< 0.1%
37	1015	< 0.1%
36	5747	0.1%
35	2768	0.1%
34	3685	0.1%
33	3650	0.1%
32	8010	0.1%
31	4375	0.1%
30	12449	0.2%

relative_risk
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	44
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.022475708

Minimum	0
Maximum	13.333333
Zeros	5495997
Zeros (%)	99.4%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	13.333333
Range	13.333333
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.30339287
Coefficient of variation (CV)	13.498701
Kurtosis	239.36284
Mean	0.022475708
Median Absolute Deviation (MAD)	0
Skewness	14.600915
Sum	124240.18
Variance	0.092047232
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
0	5495997	99.4%
3.8	10034	0.2%
3.833333333	6955	0.1%
3.5	3085	0.1%
3.6	2955	0.1%
3.666666667	2508	< 0.1%
3.4	1337	< 0.1%
3.75	1098	< 0.1%
3	667	< 0.1%
7.333333333	640	< 0.1%
Other values (34)	2478	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5495997	99.4%
1	30	< 0.1%
2	56	< 0.1%
2.5	58	< 0.1%
3	667	< 0.1%
3.25	125	< 0.1%
3.333333333	183	< 0.1%
3.4	1337	< 0.1%
3.5	3085	0.1%
3.571428571	49	< 0.1%

Value	Count	Frequency (%)
13.33333333	6	< 0.1%
12	6	< 0.1%
10.5	42	< 0.1%
10.2	30	< 0.1%
9.75	4	< 0.1%
9.6	10	< 0.1%
9	6	< 0.1%
8	2	< 0.1%
7.428571429	35	< 0.1%
7.333333333	640	< 0.1%

average_severity_pipe
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.9981682

Minimum	1
Maximum	4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	4
median	4
Q3	4
95-th percentile	4
Maximum	4
Range	3
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.029360141
Coefficient of variation (CV)	0.0073433982
Kurtosis	1294.6955
Mean	3.9981682
Median Absolute Deviation (MAD)	0
Skewness	-27.16596
Sum	22100890
Variance	0.0008620179
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
4	5495997	99.4%
3.8	10034	0.2%
3.833333333	6955	0.1%
3.6	3376	0.1%
3.5	3350	0.1%
3.666666667	3148	0.1%
3.4	1440	< 0.1%
3.75	1098	< 0.1%
3	820	< 0.1%
3.857142857	427	< 0.1%
Other values (16)	1109	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	30	< 0.1%
1.5	1	< 0.1%
2	60	< 0.1%
2.5	66	< 0.1%
2.666666667	8	< 0.1%
2.8	15	< 0.1%
3	820	< 0.1%
3.166666667	12	< 0.1%
3.2	105	< 0.1%
3.25	158	< 0.1%

Value	Count	Frequency (%)
4	5495997	99.4%
3.9	30	< 0.1%
3.888888889	18	< 0.1%
3.875	56	< 0.1%
3.857142857	427	< 0.1%
3.833333333	6955	0.1%
3.8	10034	0.2%
3.777777778	9	< 0.1%
3.75	1098	< 0.1%
3.714285714	119	< 0.1%

Incidence
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	316.3 MiB

0.0	5519945
1.0	7809

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	16583262
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	5519945	99.9%
1.0	7809	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	5519945	99.9%
1.0	7809	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	11047699	66.6%
.	5527754	33.3%
1	7809	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11055508	66.7%
Other Punctuation	5527754	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	11047699	99.9%
1	7809	0.1%

Other Punctuation

Value	Count	Frequency (%)
.	5527754	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	16583262	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	11047699	66.6%
.	5527754	33.3%
1	7809	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16583262	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	11047699	66.6%
.	5527754	33.3%
1	7809	< 0.1%

YearBuilt
Real number (ℝ)

Distinct	38
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2002.6526

Minimum	1983
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	1983
5-th percentile	1989
Q1	1998
median	2003
Q3	2008
95-th percentile	2014
Maximum	2020
Range	37
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	7.200412
Coefficient of variation (CV)	0.0035954373
Kurtosis	-0.29095334
Mean	2002.6526
Median Absolute Deviation (MAD)	5
Skewness	-0.28213615
Sum	1.1070171 × 10¹⁰
Variance	51.845933
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
2002	377039	6.8%
2004	333779	6.0%
2005	301508	5.5%
2003	294446	5.3%
2001	290790	5.3%
2006	284835	5.2%
2008	284419	5.1%
2007	264959	4.8%
1999	260904	4.7%
2000	250976	4.5%
Other values (28)	2584099	46.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1983	13021	0.2%
1984	16160	0.3%
1985	23709	0.4%
1986	37662	0.7%
1987	56511	1.0%
1988	70978	1.3%
1989	73552	1.3%
1990	73740	1.3%
1991	76985	1.4%
1992	104464	1.9%

Value	Count	Frequency (%)
2020	1244	< 0.1%
2019	5909	0.1%
2018	15495	0.3%
2017	31795	0.6%
2016	103469	1.9%
2015	113161	2.0%
2014	97402	1.8%
2013	107930	2.0%
2012	143821	2.6%
2011	149157	2.7%

Diameter
Real number (ℝ)

Distinct	61
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.11711464

Minimum	0.01
Maximum	0.6096
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0.01
5-th percentile	0.063
Q1	0.09
median	0.11
Q3	0.16
95-th percentile	0.2
Maximum	0.6096
Range	0.5996
Interquartile range (IQR)	0.07

Descriptive statistics

Standard deviation	0.054578394
Coefficient of variation (CV)	0.46602535
Kurtosis	3.5586866
Mean	0.11711464
Median Absolute Deviation (MAD)	0.047
Skewness	1.397711
Sum	647380.95
Variance	0.0029788011
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.11	1486633	26.9%
0.063	1048452	19.0%
0.09	1015013	18.4%
0.16	754563	13.7%
0.2	519279	9.4%
0.04	106468	1.9%
0.1524	88428	1.6%
0.1016	72764	1.3%
0.25	67799	1.2%
0.2032	63532	1.1%
Other values (51)	304823	5.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	158	< 0.1%
0.011	60	< 0.1%
0.012	1334	< 0.1%
0.0127	11	< 0.1%
0.013	105	< 0.1%
0.014	43	< 0.1%
0.015	4246	0.1%
0.016	1070	< 0.1%
0.018	6	< 0.1%
0.019	3325	0.1%

Value	Count	Frequency (%)
0.6096	67	< 0.1%
0.5588	46	< 0.1%
0.508	2404	< 0.1%
0.5	102	< 0.1%
0.4572	1853	< 0.1%
0.4064	7656	0.1%
0.4	561	< 0.1%
0.3556	474	< 0.1%
0.355	108	< 0.1%
0.35	372	< 0.1%

Length
Real number (ℝ)

Distinct	124031
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.996803

Minimum	0.005
Maximum	105.748
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0.005
5-th percentile	1.002
Q1	3.679
median	11.918
Q3	35.228
95-th percentile	79.588
Maximum	105.748
Range	105.743
Interquartile range (IQR)	31.549

Descriptive statistics

Standard deviation	25.338633
Coefficient of variation (CV)	1.1018329
Kurtosis	0.9205847
Mean	22.996803
Median Absolute Deviation (MAD)	10.018
Skewness	1.3389394
Sum	1.2712067 × 10⁸
Variance	642.04632
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	26510	0.5%
1	25323	0.5%
0.5	18375	0.3%
1.5	18041	0.3%
1.002	16884	0.3%
1.003	10153	0.2%
1.001	9546	0.2%
3	8694	0.2%
2.004	8567	0.2%
1.2	8287	0.1%
Other values (124021)	5377374	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005	14	< 0.1%
0.006	19	< 0.1%
0.007	14	< 0.1%
0.008	20	< 0.1%
0.009	19	< 0.1%
0.01	61	< 0.1%
0.011	25	< 0.1%
0.012	12	< 0.1%
0.013	31	< 0.1%
0.014	8	< 0.1%

Value	Count	Frequency (%)
105.748	8	< 0.1%
105.746	10	< 0.1%
105.745	20	< 0.1%
105.743	6	< 0.1%
105.742	18	< 0.1%
105.741	5	< 0.1%
105.739	11	< 0.1%
105.738	5	< 0.1%
105.737	5	< 0.1%
105.736	13	< 0.1%

Pressure
Real number (ℝ)

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.6359134

Minimum	0.025
Maximum	80
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0.025
5-th percentile	0.025
Q1	0.1
median	0.15
Q3	4
95-th percentile	16
Maximum	80
Range	79.975
Interquartile range (IQR)	3.9

Descriptive statistics

Standard deviation	5.9673826
Coefficient of variation (CV)	2.2638766
Kurtosis	53.463477
Mean	2.6359134
Median Absolute Deviation (MAD)	0.125
Skewness	6.2536418
Sum	14570681
Variance	35.609656
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
4	1605762	29.0%
0.15	1559337	28.2%
0.025	1038331	18.8%
0.1	562184	10.2%
16	251041	4.5%
5	159352	2.9%
0.4	143799	2.6%
1.7	112953	2.0%
49.5	29224	0.5%
0.05	19994	0.4%
Other values (10)	45777	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.025	1038331	18.8%
0.05	19994	0.4%
0.1	562184	10.2%
0.15	1559337	28.2%
0.4	143799	2.6%
1.7	112953	2.0%
2	11816	0.2%
4	1605762	29.0%
5	159352	2.9%
10	6189	0.1%

Value	Count	Frequency (%)
80	2391	< 0.1%
72	4851	0.1%
59.5	2784	0.1%
49.5	29224	0.5%
45	2085	< 0.1%
40	667	< 0.1%
36	9169	0.2%
25	677	< 0.1%
16	251041	4.5%
12	5148	0.1%

NumConnections
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	34
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.77901115

Minimum	0
Maximum	34
Zeros	3452531
Zeros (%)	62.5%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	4
Maximum	34
Range	34
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.5070289
Coefficient of variation (CV)	1.9345409
Kurtosis	22.453819
Mean	0.77901115
Median Absolute Deviation (MAD)	0
Skewness	3.7073377
Sum	4306182
Variance	2.2711362
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
0	3452531	62.5%
1	1130476	20.5%
2	449447	8.1%
3	205495	3.7%
4	114210	2.1%
5	64739	1.2%
6	40059	0.7%
7	23399	0.4%
8	15997	0.3%
9	10360	0.2%
Other values (24)	21041	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3452531	62.5%
1	1130476	20.5%
2	449447	8.1%
3	205495	3.7%
4	114210	2.1%
5	64739	1.2%
6	40059	0.7%
7	23399	0.4%
8	15997	0.3%
9	10360	0.2%

Value	Count	Frequency (%)
34	5	< 0.1%
33	10	< 0.1%
32	2	< 0.1%
30	10	< 0.1%
29	17	< 0.1%
28	38	< 0.1%
27	19	< 0.1%
26	29	< 0.1%
25	17	< 0.1%
24	44	< 0.1%

NumConnectionsUnder
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5526923
1	811
2	20

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5526923	> 99.9%
1	811	< 0.1%
2	20	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5526923	> 99.9%
1	811	< 0.1%
2	20	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	5526923	> 99.9%
1	811	< 0.1%
2	20	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5526923	> 99.9%
1	811	< 0.1%
2	20	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5526923	> 99.9%
1	811	< 0.1%
2	20	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5526923	> 99.9%
1	811	< 0.1%
2	20	< 0.1%

BoolBridle
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5527754

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5527754	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5527754	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	5527754	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5527754	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5527754	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5527754	100.0%

aspect
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	630733
Distinct (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6074411

Minimum	0.00060597981
Maximum	177165.35
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0.00060597981
5-th percentile	0.0053777319
Q1	0.040479275
median	0.37411533
Q3	2.8811573
95-th percentile	31.682666
Maximum	177165.35
Range	177165.35
Interquartile range (IQR)	2.840678

Descriptive statistics

Standard deviation	121.10349
Coefficient of variation (CV)	15.919084
Kurtosis	1658321.7
Mean	7.6074411
Median Absolute Deviation (MAD)	0.36447697
Skewness	1145.0382
Sum	42052063
Variance	14666.056
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.9090909091	4616	0.1%
63.36533283	3981	0.1%
0.6818181818	3682	0.1%
1.363636364	3048	0.1%
31.74603175	2905	0.1%
63.49206349	2774	0.1%
22.22222222	2699	< 0.1%
1.875	2599	< 0.1%
0.625	2217	< 0.1%
0.46875	2122	< 0.1%
Other values (630723)	5497111	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0006059798088	5	< 0.1%
0.0006389939679	5	< 0.1%
0.0006502790519	10	< 0.1%
0.0006605229228	6	< 0.1%
0.0006862023913	5	< 0.1%
0.0006912722728	5	< 0.1%
0.0007513142364	6	< 0.1%
0.0007527322676	6	< 0.1%
0.0007535827964	5	< 0.1%
0.0007541843278	6	< 0.1%

Value	Count	Frequency (%)
177165.3543	2	< 0.1%
25000	1	< 0.1%
24242.42424	1	< 0.1%
20997.37533	1	< 0.1%
14173.22835	1	< 0.1%
13227.51323	4	< 0.1%
13123.35958	2	< 0.1%
12698.4127	7	< 0.1%
12500	2	< 0.1%
10582.01058	4	< 0.1%

Relative_Thickness
Real number (ℝ)

Distinct	302
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5430606

Minimum	0.00035277778
Maximum	24.384
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0.00035277778
5-th percentile	0.01
Q1	0.0225
median	0.6
Q3	1.1
95-th percentile	8
Maximum	24.384
Range	24.383647
Interquartile range (IQR)	1.0775

Descriptive statistics

Standard deviation	2.5296167
Coefficient of variation (CV)	1.6393502
Kurtosis	3.8151648
Mean	1.5430606
Median Absolute Deviation (MAD)	0.5775
Skewness	2.0836666
Sum	8529659.5
Variance	6.3989606
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.7333333333	640450	11.6%
0.01575	601313	10.9%
0.0225	482236	8.7%
4.4	340519	6.2%
6.4	305983	5.5%
0.6	285971	5.2%
1.066666667	250456	4.5%
0.0275	227225	4.1%
8	201685	3.6%
0.42	196435	3.6%
Other values (292)	1995481	36.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0003527777778	36	< 0.1%
0.0005291666667	35	< 0.1%
0.0005644444444	1	< 0.1%
0.000635	6	< 0.1%
0.0007055555556	108	< 0.1%
0.0007696969697	18	< 0.1%
0.0008537815126	171	< 0.1%
0.0008819444444	5	< 0.1%
0.0009525	100	< 0.1%
0.001026262626	256	< 0.1%

Value	Count	Frequency (%)
24.384	26	< 0.1%
20.32	32	< 0.1%
20	102	< 0.1%
18.288	8	< 0.1%
16.256	490	< 0.1%
16	540	< 0.1%
14.224	10	< 0.1%
14.2	11	< 0.1%
14	372	< 0.1%
12.6	30008	0.5%

pipe_area
Real number (ℝ)

Distinct	408200
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.552833

Minimum	0.000502656
Maximum	189.60639
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0.000502656
5-th percentile	0.28817268
Q1	1.1873269
median	3.9659558
Q3	11.743489
95-th percentile	31.243589
Maximum	189.60639
Range	189.60589
Interquartile range (IQR)	10.556162

Descriptive statistics

Standard deviation	11.260104
Coefficient of variation (CV)	1.316535
Kurtosis	9.4298947
Mean	8.552833
Median Absolute Deviation (MAD)	3.3571138
Skewness	2.5234955
Sum	47277957
Variance	126.78995
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.691152	6984	0.1%
0.345576	6337	0.1%
0.518364	6286	0.1%
0.1983166416	5889	0.1%
0.251328	5559	0.1%
0.1979208	5404	0.1%
0.565488	5310	0.1%
0.3958416	4974	0.1%
0.282744	4575	0.1%
1.005312	4239	0.1%
Other values (408190)	5472197	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.000502656	1	< 0.1%
0.000518364	1	< 0.1%
0.0006031872	5	< 0.1%
0.0007979664	2	< 0.1%
0.000989604	7	< 0.1%
0.001005312	2	< 0.1%
0.0011875248	8	< 0.1%
0.0012534984	1	< 0.1%
0.00141372	2	< 0.1%
0.00143633952	1	< 0.1%

Value	Count	Frequency (%)
189.6063922	5	< 0.1%
167.5825196	1	< 0.1%
166.409509	4	< 0.1%
166.3345001	6	< 0.1%
166.3265205	5	< 0.1%
164.9856177	6	< 0.1%
164.1991421	4	< 0.1%
163.4761845	5	< 0.1%
162.9718697	4	< 0.1%
155.8460298	5	< 0.1%

area_connection
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	294433
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.19393303

Minimum	0
Maximum	1989.4321
Zeros	3452531
Zeros (%)	62.5%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.13199728
95-th percentile	0.6884723
Maximum	1989.4321
Range	1989.4321
Interquartile range (IQR)	0.13199728

Descriptive statistics

Standard deviation	2.0638916
Coefficient of variation (CV)	10.64229
Kurtosis	371154.1
Mean	0.19393303
Median Absolute Deviation (MAD)	0
Skewness	465.96586
Sum	1072014.1
Variance	4.2596483
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3452531	62.5%
1.010505212	838	< 0.1%
2.52626303	792	< 0.1%
5.052526061	738	< 0.1%
0.8420876768	711	< 0.1%
5.042441179	682	< 0.1%
1.263131515	559	< 0.1%
1.684175354	558	< 0.1%
0.7217894373	528	< 0.1%
7.957728546	464	< 0.1%
Other values (294423)	2069353	37.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3452531	62.5%
0.007715556516	5	< 0.1%
0.009769187457	5	< 0.1%
0.009792381384	5	< 0.1%
0.009840825945	5	< 0.1%
0.009911967005	5	< 0.1%
0.009919848549	5	< 0.1%
0.009930571972	10	< 0.1%
0.009956403025	5	< 0.1%
0.009956599227	6	< 0.1%

Value	Count	Frequency (%)
1989.432136	1	< 0.1%
1929.146314	1	< 0.1%
1253.185598	2	< 0.1%
1010.505212	2	< 0.1%
797.7672728	1	< 0.1%
530.5152364	2	< 0.1%
361.7149339	1	< 0.1%
360.8947186	3	< 0.1%
234.9144958	1	< 0.1%
226.0718337	1	< 0.1%

incidence_area
Real number (ℝ)

SKEWED ZEROS

Distinct	7154
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0012112147

Minimum	0
Maximum	142.1023
Zeros	5519945
Zeros (%)	99.9%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	142.1023
Range	142.1023
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.14039461
Coefficient of variation (CV)	115.91224
Kurtosis	336851.02
Mean	0.0012112147
Median Absolute Deviation (MAD)	0
Skewness	451.99921
Sum	6695.2971
Variance	0.019710647
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5519945	99.9%
3.978864273	16	< 0.1%
7.957728546	10	< 0.1%
5.052526061	8	< 0.1%
21.22060946	6	< 0.1%
3.536768243	6	< 0.1%
3.9808547	6	< 0.1%
15.91545709	6	< 0.1%
5.305152364	5	< 0.1%
1.989432136	5	< 0.1%
Other values (7144)	7741	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5519945	99.9%
0.009659922876	1	< 0.1%
0.009667593515	1	< 0.1%
0.009801689822	1	< 0.1%
0.01009112637	1	< 0.1%
0.01015348424	1	< 0.1%
0.01017956655	1	< 0.1%
0.01018410014	1	< 0.1%
0.01019055084	1	< 0.1%
0.01019826426	2	< 0.1%

Value	Count	Frequency (%)
142.1022955	1	< 0.1%
117.5006061	1	< 0.1%
89.91783668	1	< 0.1%
52.94563238	1	< 0.1%
51.03561678	1	< 0.1%
50.04860721	1	< 0.1%
45.60302892	1	< 0.1%
45.47273455	1	< 0.1%
41.44650284	1	< 0.1%
39.78864273	2	< 0.1%

connection_bool
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	4583007
1	944747

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	4583007	82.9%
1	944747	17.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	4583007	82.9%
1	944747	17.1%

Most occurring characters

Value	Count	Frequency (%)
0	4583007	82.9%
1	944747	17.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4583007	82.9%
1	944747	17.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4583007	82.9%
1	944747	17.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4583007	82.9%
1	944747	17.1%

Severity_high
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5527157
1	597

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5527157	> 99.9%
1	597	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5527157	> 99.9%
1	597	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	5527157	> 99.9%
1	597	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5527157	> 99.9%
1	597	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5527157	> 99.9%
1	597	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5527157	> 99.9%
1	597	< 0.1%

Severity_medium
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5526660
1	1094

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5526660	> 99.9%
1	1094	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5526660	> 99.9%
1	1094	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	5526660	> 99.9%
1	1094	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5526660	> 99.9%
1	1094	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5526660	> 99.9%
1	1094	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5526660	> 99.9%
1	1094	< 0.1%

Severity_low
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5521636
1	6118

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5521636	99.9%
1	6118	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5521636	99.9%
1	6118	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	5521636	99.9%
1	6118	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5521636	99.9%
1	6118	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5521636	99.9%
1	6118	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5521636	99.9%
1	6118	0.1%

gas_natural
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

1	5428949
0	98805

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	5428949	98.2%
0	98805	1.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	5428949	98.2%
0	98805	1.8%

Most occurring characters

Value	Count	Frequency (%)
1	5428949	98.2%
0	98805	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	5428949	98.2%
0	98805	1.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	5428949	98.2%
0	98805	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	5428949	98.2%
0	98805	1.8%

Material_Acrylonitrile-Butadiene-Styrene
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5151416
1	376338

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5151416	93.2%
1	376338	6.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5151416	93.2%
1	376338	6.8%

Most occurring characters

Value	Count	Frequency (%)
0	5151416	93.2%
1	376338	6.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5151416	93.2%
1	376338	6.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5151416	93.2%
1	376338	6.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5151416	93.2%
1	376338	6.8%

Material_Copper
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5514562
1	13192

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5514562	99.8%
1	13192	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5514562	99.8%
1	13192	0.2%

Most occurring characters

Value	Count	Frequency (%)
0	5514562	99.8%
1	13192	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5514562	99.8%
1	13192	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5514562	99.8%
1	13192	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5514562	99.8%
1	13192	0.2%

Material_Fiberglass-Reinforced Plastic
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5418775
1	108979

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5418775	98.0%
1	108979	2.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5418775	98.0%
1	108979	2.0%

Most occurring characters

Value	Count	Frequency (%)
0	5418775	98.0%
1	108979	2.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5418775	98.0%
1	108979	2.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5418775	98.0%
1	108979	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5418775	98.0%
1	108979	2.0%

Material_Polyethylene
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

1	5006277
0	521477

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	5006277	90.6%
0	521477	9.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	5006277	90.6%
0	521477	9.4%

Most occurring characters

Value	Count	Frequency (%)
1	5006277	90.6%
0	521477	9.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	5006277	90.6%
0	521477	9.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	5006277	90.6%
0	521477	9.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	5006277	90.6%
0	521477	9.4%

Material_Polypropylene
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5508813
1	18941

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5508813	99.7%
1	18941	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5508813	99.7%
1	18941	0.3%

Most occurring characters

Value	Count	Frequency (%)
0	5508813	99.7%
1	18941	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5508813	99.7%
1	18941	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5508813	99.7%
1	18941	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5508813	99.7%
1	18941	0.3%

Diameter2
Real number (ℝ)

Distinct	61
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.016694641

Minimum	0.0001
Maximum	0.37161216
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0.0001
5-th percentile	0.003969
Q1	0.0081
median	0.0121
Q3	0.0256
95-th percentile	0.04
Maximum	0.37161216
Range	0.37151216
Interquartile range (IQR)	0.0175

Descriptive statistics

Standard deviation	0.017866221
Coefficient of variation (CV)	1.0701771
Kurtosis	32.227845
Mean	0.016694641
Median Absolute Deviation (MAD)	0.008131
Skewness	4.052524
Sum	92283.866
Variance	0.00031920187
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0121	1486633	26.9%
0.003969	1048452	19.0%
0.0081	1015013	18.4%
0.0256	754563	13.7%
0.04	519279	9.4%
0.0016	106468	1.9%
0.02322576	88428	1.6%
0.01032256	72764	1.3%
0.0625	67799	1.2%
0.04129024	63532	1.1%
Other values (51)	304823	5.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0001	158	< 0.1%
0.000121	60	< 0.1%
0.000144	1334	< 0.1%
0.00016129	11	< 0.1%
0.000169	105	< 0.1%
0.000196	43	< 0.1%
0.000225	4246	0.1%
0.000256	1070	< 0.1%
0.000324	6	< 0.1%
0.000361	3325	0.1%

Value	Count	Frequency (%)
0.37161216	67	< 0.1%
0.31225744	46	< 0.1%
0.258064	2404	< 0.1%
0.25	102	< 0.1%
0.20903184	1853	< 0.1%
0.16516096	7656	0.1%
0.16	561	< 0.1%
0.12645136	474	< 0.1%
0.126025	108	< 0.1%
0.1225	372	< 0.1%

Length2
Real number (ℝ)

Distinct	123651
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1170.8991

Minimum	2.5 × 10^-5
Maximum	11182.64
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	2.5 × 10^-5
5-th percentile	1.004004
Q1	13.535041
median	142.03872
Q3	1241.012
95-th percentile	6334.2497
Maximum	11182.64
Range	11182.639
Interquartile range (IQR)	1227.4769

Descriptive statistics

Standard deviation	2136.7845
Coefficient of variation (CV)	1.8249092
Kurtosis	5.8325417
Mean	1170.8991
Median Absolute Deviation (MAD)	140.35132
Skewness	2.4570189
Sum	6.4724424 × 10⁹
Variance	4565848.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	26510	0.5%
1	25323	0.5%
0.25	18375	0.3%
2.25	18041	0.3%
1.004004	16884	0.3%
1.006009	10153	0.2%
1.002001	9546	0.2%
9	8694	0.2%
4.016016	8567	0.2%
1.44	8287	0.1%
Other values (123641)	5377374	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.5 × 10^-5	14	< 0.1%
3.6 × 10^-5	19	< 0.1%
4.9 × 10^-5	14	< 0.1%
6.4 × 10^-5	20	< 0.1%
8.1 × 10^-5	19	< 0.1%
0.0001	61	< 0.1%
0.000121	25	< 0.1%
0.000144	12	< 0.1%
0.000169	31	< 0.1%
0.000196	8	< 0.1%

Value	Count	Frequency (%)
11182.6395	8	< 0.1%
11182.21652	10	< 0.1%
11182.00503	20	< 0.1%
11181.58205	6	< 0.1%
11181.37056	18	< 0.1%
11181.15908	5	< 0.1%
11180.73612	11	< 0.1%
11180.52464	5	< 0.1%
11180.31317	5	< 0.1%
11180.1017	13	< 0.1%

Pressure2
Real number (ℝ)

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	42.557688

Minimum	0.000625
Maximum	6400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	0.000625
5-th percentile	0.000625
Q1	0.01
median	0.0225
Q3	16
95-th percentile	256
Maximum	6400
Range	6399.9994
Interquartile range (IQR)	15.99

Descriptive statistics

Standard deviation	292.11493
Coefficient of variation (CV)	6.8639754
Kurtosis	214.48433
Mean	42.557688
Median Absolute Deviation (MAD)	0.021875
Skewness	13.352417
Sum	2.3524843 × 10⁸
Variance	85331.131
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
16	1605762	29.0%
0.0225	1559337	28.2%
0.000625	1038331	18.8%
0.01	562184	10.2%
256	251041	4.5%
25	159352	2.9%
0.16	143799	2.6%
2.89	112953	2.0%
2450.25	29224	0.5%
0.0025	19994	0.4%
Other values (10)	45777	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.000625	1038331	18.8%
0.0025	19994	0.4%
0.01	562184	10.2%
0.0225	1559337	28.2%
0.16	143799	2.6%
2.89	112953	2.0%
4	11816	0.2%
16	1605762	29.0%
25	159352	2.9%
100	6189	0.1%

Value	Count	Frequency (%)
6400	2391	< 0.1%
5184	4851	0.1%
3540.25	2784	0.1%
2450.25	29224	0.5%
2025	2085	< 0.1%
1600	667	< 0.1%
1296	9169	0.2%
625	677	< 0.1%
256	251041	4.5%
144	5148	0.1%

Province
Categorical

Distinct	38
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	342.1 MiB

barcelona	1520717
valencia	562995
madrid	520803
girona	315159
tarragona	310243
Other values (33)	2297837

Length

Max length	11
Median length	10
Mean length	7.8892478
Min length	4

Characters and Unicode

Total characters	43609821
Distinct characters	21
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ciudad real
2nd row	ciudad real
3rd row	ciudad real
4th row	ciudad real
5th row	ciudad real

Common Values

Value	Count	Frequency (%)
barcelona	1520717	27.5%
valencia	562995	10.2%
madrid	520803	9.4%
girona	315159	5.7%
tarragona	310243	5.6%
alicante	240594	4.4%
la coruna	161931	2.9%
sevilla	150050	2.7%
pontevedra	147680	2.7%
valladolid	146228	2.6%
Other values (28)	1451354	26.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
barcelona	1520717	25.9%
valencia	562995	9.6%
madrid	520803	8.9%
girona	315159	5.4%
tarragona	310243	5.3%
alicante	240594	4.1%
la	239413	4.1%
coruna	161931	2.8%
sevilla	150050	2.6%
pontevedra	147680	2.5%
Other values (30)	1695777	28.9%

Most occurring characters

Value	Count	Frequency (%)
a	9520063	21.8%
l	4531042	10.4%
r	3835397	8.8%
n	3703267	8.5%
e	3670776	8.4%
o	3532012	8.1%
c	3008379	6.9%
i	2360352	5.4%
d	2185128	5.0%
b	1717608	3.9%
Other values (11)	5545797	12.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	43272213	99.2%
Space Separator	337608	0.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	9520063	22.0%
l	4531042	10.5%
r	3835397	8.9%
n	3703267	8.6%
e	3670776	8.5%
o	3532012	8.2%
c	3008379	7.0%
i	2360352	5.5%
d	2185128	5.0%
b	1717608	4.0%
Other values (10)	5208189	12.0%

Space Separator

Value	Count	Frequency (%)
	337608	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	43272213	99.2%
Common	337608	0.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	9520063	22.0%
l	4531042	10.5%
r	3835397	8.9%
n	3703267	8.6%
e	3670776	8.5%
o	3532012	8.2%
c	3008379	7.0%
i	2360352	5.5%
d	2185128	5.0%
b	1717608	4.0%
Other values (10)	5208189	12.0%

Common

Value	Count	Frequency (%)
	337608	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43609821	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	9520063	21.8%
l	4531042	10.4%
r	3835397	8.8%
n	3703267	8.5%
e	3670776	8.4%
o	3532012	8.1%
c	3008379	6.9%
i	2360352	5.4%
d	2185128	5.0%
b	1717608	3.9%
Other values (11)	5545797	12.7%

Town
Categorical

Distinct	1884
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	355.2 MiB

madrid	352803
barcelona	220382
valencia	91691
sevilla	84752
terrassa	66997
Other values (1879)	4711129

Length

Max length	25
Median length	22
Mean length	10.386721
Min length	3

Characters and Unicode

Total characters	57415236
Distinct characters	29
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	torralba de calatrava
2nd row	torralba de calatrava
3rd row	torralba de calatrava
4th row	torralba de calatrava
5th row	torralba de calatrava

Common Values

Value	Count	Frequency (%)
madrid	352803	6.4%
barcelona	220382	4.0%
valencia	91691	1.7%
sevilla	84752	1.5%
terrassa	66997	1.2%
sabadell	64005	1.2%
alicante/alacant	63025	1.1%
vigo	55248	1.0%
malaga	55163	1.0%
cordoba	51296	0.9%
Other values (1874)	4422392	80.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	827915	9.5%
madrid	352803	4.0%
del	297452	3.4%
sant	241253	2.8%
barcelona	220382	2.5%
la	214895	2.5%
valles	128361	1.5%
llobregat	101428	1.2%
valencia	93930	1.1%
sevilla	84752	1.0%
Other values (2046)	6194480	70.7%

Most occurring characters

Value	Count	Frequency (%)
a	9652351	16.8%
e	5745086	10.0%
l	5624238	9.8%
r	4294019	7.5%
o	3425474	6.0%
	3229924	5.6%
d	3156758	5.5%
n	3123478	5.4%
s	2955643	5.1%
i	2821441	4.9%
Other values (19)	13386824	23.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	53890741	93.9%
Space Separator	3229924	5.6%
Other Punctuation	207528	0.4%
Dash Punctuation	87031	0.2%
Decimal Number	12	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	9652351	17.9%
e	5745086	10.7%
l	5624238	10.4%
r	4294019	8.0%
o	3425474	6.4%
d	3156758	5.9%
n	3123478	5.8%
s	2955643	5.5%
i	2821441	5.2%
t	2323037	4.3%
Other values (14)	10769216	20.0%

Other Punctuation

Value	Count	Frequency (%)
/	202734	97.7%
.	4794	2.3%

Space Separator

Value	Count	Frequency (%)
	3229924	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	87031	100.0%

Decimal Number

Value	Count	Frequency (%)
7	12	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	53890741	93.9%
Common	3524495	6.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	9652351	17.9%
e	5745086	10.7%
l	5624238	10.4%
r	4294019	8.0%
o	3425474	6.4%
d	3156758	5.9%
n	3123478	5.8%
s	2955643	5.5%
i	2821441	5.2%
t	2323037	4.3%
Other values (14)	10769216	20.0%

Common

Value	Count	Frequency (%)
	3229924	91.6%
/	202734	5.8%
-	87031	2.5%
.	4794	0.1%
7	12	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	57415236	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	9652351	16.8%
e	5745086	10.0%
l	5624238	9.8%
r	4294019	7.5%
o	3425474	6.0%
	3229924	5.6%
d	3156758	5.5%
n	3123478	5.4%
s	2955643	5.1%
i	2821441	4.9%
Other values (19)	13386824	23.3%

TownCount
Real number (ℝ)

Distinct	1188
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56625.732

Minimum	1
Maximum	401156
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1399
Q1	5706
median	12897
Q3	41902
95-th percentile	401156
Maximum	401156
Range	401155
Interquartile range (IQR)	36196

Descriptive statistics

Standard deviation	107032.55
Coefficient of variation (CV)	1.8901752
Kurtosis	4.7882447
Mean	56625.732
Median Absolute Deviation (MAD)	9392
Skewness	2.485763
Sum	3.1301312 × 10¹¹
Variance	1.1455968 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
401156	352803	6.4%
290182	220382	4.0%
124155	91691	1.7%
100982	84752	1.5%
77985	66997	1.2%
75580	64005	1.2%
68130	63025	1.1%
61439	55248	1.0%
72471	55163	1.0%
56505	51296	0.9%
Other values (1178)	4422392	80.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4	< 0.1%
2	126	< 0.1%
3	19	< 0.1%
4	115	< 0.1%
5	32	< 0.1%
6	275	< 0.1%
7	48	< 0.1%
8	227	< 0.1%
9	74	< 0.1%
10	341	< 0.1%

Value	Count	Frequency (%)
401156	352803	6.4%
290182	220382	4.0%
124155	91691	1.7%
100982	84752	1.5%
77985	66997	1.2%
75580	64005	1.2%
72471	55163	1.0%
68130	63025	1.1%
63033	47690	0.9%
61439	55248	1.0%

Autonomía_Andalucía
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5035580
1	492174

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5035580	91.1%
1	492174	8.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5035580	91.1%
1	492174	8.9%

Most occurring characters

Value	Count	Frequency (%)
0	5035580	91.1%
1	492174	8.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5035580	91.1%
1	492174	8.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5035580	91.1%
1	492174	8.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5035580	91.1%
1	492174	8.9%

Autonomía_Aragón
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5503694
1	24060

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5503694	99.6%
1	24060	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5503694	99.6%
1	24060	0.4%

Most occurring characters

Value	Count	Frequency (%)
0	5503694	99.6%
1	24060	0.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5503694	99.6%
1	24060	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5503694	99.6%
1	24060	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5503694	99.6%
1	24060	0.4%

Autonomía_Balears (Illes)
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5521127
1	6627

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5521127	99.9%
1	6627	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5521127	99.9%
1	6627	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	5521127	99.9%
1	6627	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5521127	99.9%
1	6627	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5521127	99.9%
1	6627	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5521127	99.9%
1	6627	0.1%

Autonomía_Castilla y León
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5060339
1	467415

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5060339	91.5%
1	467415	8.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5060339	91.5%
1	467415	8.5%

Most occurring characters

Value	Count	Frequency (%)
0	5060339	91.5%
1	467415	8.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5060339	91.5%
1	467415	8.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5060339	91.5%
1	467415	8.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5060339	91.5%
1	467415	8.5%

Autonomía_Castilla-La Mancha
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5161077
1	366677

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	5161077	93.4%
1	366677	6.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5161077	93.4%
1	366677	6.6%

Most occurring characters

Value	Count	Frequency (%)
0	5161077	93.4%
1	366677	6.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5161077	93.4%
1	366677	6.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5161077	93.4%
1	366677	6.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5161077	93.4%
1	366677	6.6%

Autonomía_Cataluña
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	3222424
1	2305330

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	3222424	58.3%
1	2305330	41.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	3222424	58.3%
1	2305330	41.7%

Most occurring characters

Value	Count	Frequency (%)
0	3222424	58.3%
1	2305330	41.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	3222424	58.3%
1	2305330	41.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	3222424	58.3%
1	2305330	41.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	3222424	58.3%
1	2305330	41.7%

Autonomía_Comunidad Valenciana
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	4634278
1	893476

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	4634278	83.8%
1	893476	16.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	4634278	83.8%
1	893476	16.2%

Most occurring characters

Value	Count	Frequency (%)
0	4634278	83.8%
1	893476	16.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4634278	83.8%
1	893476	16.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4634278	83.8%
1	893476	16.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4634278	83.8%
1	893476	16.2%

Autonomía_Extremadura
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5522325
1	5429

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5522325	99.9%
1	5429	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5522325	99.9%
1	5429	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	5522325	99.9%
1	5429	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5522325	99.9%
1	5429	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5522325	99.9%
1	5429	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5522325	99.9%
1	5429	0.1%

Autonomía_Galicia
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5154667
1	373087

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5154667	93.3%
1	373087	6.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5154667	93.3%
1	373087	6.7%

Most occurring characters

Value	Count	Frequency (%)
0	5154667	93.3%
1	373087	6.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5154667	93.3%
1	373087	6.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5154667	93.3%
1	373087	6.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5154667	93.3%
1	373087	6.7%

Autonomía_Madrid (Comunidad de)
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5012380
1	515374

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5012380	90.7%
1	515374	9.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5012380	90.7%
1	515374	9.3%

Most occurring characters

Value	Count	Frequency (%)
0	5012380	90.7%
1	515374	9.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5012380	90.7%
1	515374	9.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5012380	90.7%
1	515374	9.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5012380	90.7%
1	515374	9.3%

Autonomía_Navarra (Comunidad Foral de)
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5527131
1	623

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5527131	> 99.9%
1	623	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5527131	> 99.9%
1	623	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	5527131	> 99.9%
1	623	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5527131	> 99.9%
1	623	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5527131	> 99.9%
1	623	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5527131	> 99.9%
1	623	< 0.1%

Autonomía_Rioja (La)
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5450272
1	77482

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5450272	98.6%
1	77482	1.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5450272	98.6%
1	77482	1.4%

Most occurring characters

Value	Count	Frequency (%)
0	5450272	98.6%
1	77482	1.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5450272	98.6%
1	77482	1.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5450272	98.6%
1	77482	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5450272	98.6%
1	77482	1.4%

Madrid
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.8 MiB

0	5174951
1	352803

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5527754
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5174951	93.6%
1	352803	6.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5174951	93.6%
1	352803	6.4%

Most occurring characters

Value	Count	Frequency (%)
0	5174951	93.6%
1	352803	6.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5527754	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5174951	93.6%
1	352803	6.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	5527754	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5174951	93.6%
1	352803	6.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5527754	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5174951	93.6%
1	352803	6.4%

Auto

Heatmap
Table

	PipeId	No_Inspections	InspectionYear	Probability_rate	preventive_maintenance_rate	Age_pipe_at_inspection	Average_MonthsLastRev	MonthsLastRev	relative_risk	average_severity_pipe	YearBuilt	Diameter	Length	Pressure	NumConnections	aspect	Relative_Thickness	pipe_area	area_connection	incidence_area	Diameter2	Length2	Pressure2	TownCount	No_Incidents	pipe_inspected_frequently	Incidence	NumConnectionsUnder	connection_bool	Severity_high	Severity_medium	Severity_low	gas_natural	Material_Acrylonitrile-Butadiene-Styrene	Material_Copper	Material_Fiberglass-Reinforced Plastic	Material_Polyethylene	Material_Polypropylene	Province	Autonomía_Andalucía	Autonomía_Aragón	Autonomía_Balears (Illes)	Autonomía_Castilla y León	Autonomía_Castilla-La Mancha	Autonomía_Cataluña	Autonomía_Comunidad Valenciana	Autonomía_Extremadura	Autonomía_Galicia	Autonomía_Madrid (Comunidad de)	Autonomía_Navarra (Comunidad Foral de)	Autonomía_Rioja (La)	Madrid
PipeId	1.000	0.244	-0.115	-0.022	-0.022	-0.223	0.078	0.078	-0.022	0.022	0.243	0.114	-0.012	0.043	-0.060	-0.005	0.007	0.024	-0.067	-0.017	0.114	-0.012	0.043	-0.050	0.021	0.141	0.027	0.007	0.098	0.005	0.008	0.027	0.291	0.042	0.103	0.083	0.052	0.164	0.326	0.251	0.028	0.028	0.439	0.332	0.540	0.175	0.070	0.326	0.333	0.019	0.185	0.272
No_Inspections	0.244	1.000	-0.160	0.013	0.013	0.316	-0.212	-0.142	0.013	-0.013	-0.362	0.153	0.118	-0.112	0.052	-0.186	0.139	0.167	0.029	-0.010	0.153	0.118	-0.112	0.245	0.018	0.155	0.032	0.011	0.066	0.004	0.006	0.033	0.518	0.072	0.158	0.063	0.079	0.244	0.150	0.082	0.090	0.062	0.114	0.130	0.170	0.107	0.068	0.097	0.266	0.043	0.047	0.260
InspectionYear	-0.115	-0.160	1.000	0.005	0.005	0.253	-0.032	0.224	0.005	-0.005	0.132	-0.056	0.020	0.031	0.010	0.029	-0.043	-0.000	0.015	-0.000	-0.056	0.020	0.031	-0.061	0.003	0.058	0.006	0.003	0.011	0.003	0.003	0.007	0.166	0.037	0.051	0.017	0.032	0.081	0.046	0.031	0.035	0.028	0.014	0.021	0.032	0.022	0.036	0.042	0.017	0.017	0.031	0.022
Probability_rate	-0.022	0.013	0.005	1.000	1.000	0.038	-0.034	-0.037	1.000	-1.000	-0.039	0.003	0.053	-0.029	0.083	-0.037	0.022	0.048	0.064	0.495	0.003	0.053	-0.029	0.043	0.697	0.011	0.572	0.000	0.087	0.142	0.193	0.530	0.116	0.002	0.070	0.046	0.027	0.008	0.034	0.009	0.004	0.002	0.015	0.013	0.012	0.020	0.041	0.018	0.088	0.007	0.007	0.093
preventive_maintenance_rate	-0.022	0.013	0.005	1.000	1.000	0.038	-0.034	-0.037	1.000	-1.000	-0.039	0.003	0.053	-0.029	0.083	-0.037	0.022	0.048	0.064	0.495	0.003	0.053	-0.029	0.043	0.626	0.011	0.569	0.000	0.087	0.208	0.263	0.551	0.118	0.001	0.070	0.049	0.028	0.008	0.032	0.009	0.005	0.003	0.015	0.013	0.016	0.020	0.039	0.018	0.089	0.007	0.007	0.095
Age_pipe_at_inspection	-0.223	0.316	0.253	0.038	0.038	1.000	0.186	0.153	0.038	-0.038	-0.915	0.103	0.035	-0.247	0.075	-0.194	0.216	0.070	0.052	0.005	0.103	0.035	-0.247	0.353	0.031	0.074	0.030	0.007	0.106	0.007	0.014	0.027	0.269	0.054	0.102	0.242	0.108	0.162	0.133	0.114	0.038	0.020	0.039	0.113	0.232	0.145	0.071	0.111	0.160	0.026	0.013	0.189
Average_MonthsLastRev	0.078	-0.212	-0.032	-0.034	-0.034	0.186	1.000	0.560	-0.034	0.034	-0.189	0.040	-0.058	-0.101	-0.020	-0.051	0.089	-0.044	-0.022	-0.018	0.040	-0.058	-0.101	-0.020	0.018	0.403	0.031	0.004	0.041	0.008	0.010	0.030	0.116	0.029	0.074	0.025	0.066	0.177	0.185	0.034	0.028	0.041	0.097	0.272	0.321	0.006	0.116	0.061	0.386	0.067	0.052	0.315
MonthsLastRev	0.078	-0.142	0.224	-0.037	-0.037	0.153	0.560	1.000	-0.037	0.037	-0.054	0.027	-0.026	-0.073	-0.009	-0.055	0.067	-0.018	-0.013	-0.022	0.027	-0.026	-0.073	-0.085	0.020	0.294	0.035	0.004	0.026	0.010	0.015	0.032	0.118	0.029	0.061	0.046	0.051	0.099	0.192	0.099	0.038	0.034	0.063	0.213	0.267	0.087	0.066	0.093	0.450	0.052	0.058	0.373
relative_risk	-0.022	0.013	0.005	1.000	1.000	0.038	-0.034	-0.037	1.000	-1.000	-0.040	0.003	0.053	-0.029	0.083	-0.037	0.022	0.048	0.064	0.495	0.003	0.053	-0.029	0.043	0.997	0.009	0.509	0.000	0.087	0.179	0.241	0.453	0.042	0.001	0.033	0.044	0.026	0.008	0.030	0.007	0.004	0.002	0.015	0.009	0.011	0.020	0.014	0.014	0.086	0.004	0.007	0.089
average_severity_pipe	0.022	-0.013	-0.005	-1.000	-1.000	-0.038	0.034	0.037	-1.000	1.000	0.039	-0.003	-0.053	0.029	-0.083	0.037	-0.022	-0.048	-0.064	-0.495	-0.003	-0.053	0.029	-0.043	0.348	0.008	0.457	0.000	0.056	0.411	0.361	0.339	0.073	0.004	0.044	0.038	0.023	0.011	0.018	0.006	0.003	0.000	0.010	0.007	0.005	0.016	0.011	0.006	0.044	0.004	0.005	0.037
YearBuilt	0.243	-0.362	0.132	-0.039	-0.039	-0.915	-0.189	-0.054	-0.040	0.039	1.000	-0.117	-0.029	0.270	-0.078	0.211	-0.239	-0.069	-0.053	-0.007	-0.117	-0.029	0.270	-0.383	0.038	0.091	0.040	0.015	0.120	0.010	0.016	0.037	0.376	0.099	0.138	0.273	0.156	0.421	0.167	0.131	0.085	0.035	0.052	0.124	0.252	0.165	0.107	0.134	0.208	0.031	0.026	0.244
Diameter	0.114	0.153	-0.056	0.003	0.003	0.103	0.040	0.027	0.003	-0.003	-0.117	1.000	0.013	-0.352	-0.177	-0.447	0.605	0.292	-0.269	-0.007	1.000	0.013	-0.352	0.216	0.019	0.034	0.020	0.004	0.092	0.009	0.007	0.019	0.215	0.277	0.089	0.289	0.351	0.032	0.155	0.097	0.144	0.022	0.202	0.099	0.103	0.173	0.034	0.045	0.231	0.011	0.054	0.282
Length	-0.012	0.118	0.020	0.053	0.053	0.035	-0.058	-0.026	0.053	-0.053	-0.029	0.013	1.000	0.004	0.532	-0.494	-0.005	0.954	0.381	0.023	0.013	1.000	0.004	-0.008	0.031	0.045	0.029	0.005	0.502	0.009	0.010	0.026	0.013	0.015	0.004	0.025	0.022	0.006	0.028	0.012	0.006	0.008	0.018	0.016	0.031	0.042	0.011	0.013	0.010	0.003	0.012	0.008
Pressure	0.043	-0.112	0.031	-0.029	-0.029	-0.247	-0.101	-0.073	-0.029	0.029	0.270	-0.352	0.004	1.000	-0.132	0.830	-0.942	-0.086	-0.089	-0.009	-0.352	0.004	1.000	-0.285	0.005	0.041	0.005	0.002	0.111	0.002	0.001	0.004	0.033	0.890	0.012	0.035	0.745	0.014	0.101	0.031	0.179	0.018	0.035	0.084	0.059	0.069	0.008	0.045	0.050	0.003	0.046	0.053
NumConnections	-0.060	0.052	0.010	0.083	0.083	0.075	-0.020	-0.009	0.083	-0.083	-0.078	-0.177	0.532	-0.132	1.000	-0.334	0.054	0.451	0.943	0.038	-0.177	0.532	-0.132	0.042	0.051	0.003	0.047	0.011	0.518	0.013	0.016	0.043	0.030	0.062	0.018	0.014	0.047	0.009	0.023	0.025	0.006	0.007	0.017	0.007	0.042	0.021	0.008	0.013	0.007	0.000	0.004	0.008
aspect	-0.005	-0.186	0.029	-0.037	-0.037	-0.194	-0.051	-0.055	-0.037	0.037	0.211	-0.447	-0.494	0.830	-0.334	1.000	-0.840	-0.593	-0.213	-0.011	-0.447	-0.494	0.830	-0.223	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	0.005	0.000	0.002	0.000	0.002	0.000	0.000	0.000	0.000	0.000	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.000
Relative_Thickness	0.007	0.139	-0.043	0.022	0.022	0.216	0.089	0.067	0.022	-0.022	-0.239	0.605	-0.005	-0.942	0.054	-0.840	1.000	0.158	-0.013	0.004	0.605	-0.005	-0.942	0.296	0.034	0.087	0.025	0.002	0.099	0.015	0.012	0.019	0.065	0.126	0.024	0.439	0.169	0.018	0.176	0.066	0.032	0.016	0.144	0.129	0.229	0.134	0.015	0.130	0.324	0.005	0.058	0.421
pipe_area	0.024	0.167	-0.000	0.048	0.048	0.070	-0.044	-0.018	0.048	-0.048	-0.069	0.292	0.954	-0.086	0.451	-0.593	0.158	1.000	0.282	0.018	0.292	0.954	-0.086	0.060	0.032	0.025	0.024	0.001	0.290	0.011	0.009	0.020	0.046	0.102	0.020	0.042	0.102	0.011	0.037	0.030	0.034	0.002	0.035	0.025	0.024	0.039	0.006	0.011	0.061	0.003	0.015	0.084
area_connection	-0.067	0.029	0.015	0.064	0.064	0.052	-0.022	-0.013	0.064	-0.064	-0.053	-0.269	0.381	-0.089	0.943	-0.213	-0.013	0.282	1.000	0.031	-0.269	0.381	-0.089	0.024	0.000	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.003	0.002	0.011	0.000	0.002	0.000	0.003	0.000	0.000	0.000	0.002	0.002	0.001	0.000	0.000	0.002	0.000	0.000	0.000	0.000
incidence_area	-0.017	-0.010	-0.000	0.495	0.495	0.005	-0.018	-0.022	0.495	-0.495	-0.007	-0.007	0.023	-0.009	0.038	-0.011	0.004	0.018	0.031	1.000	-0.007	0.023	-0.009	0.011	0.026	0.000	0.097	0.000	0.000	0.000	0.004	0.108	0.015	0.000	0.028	0.000	0.005	0.002	0.002	0.002	0.000	0.000	0.001	0.000	0.002	0.000	0.008	0.001	0.003	0.000	0.000	0.000
Diameter2	0.114	0.153	-0.056	0.003	0.003	0.103	0.040	0.027	0.003	-0.003	-0.117	1.000	0.013	-0.352	-0.177	-0.447	0.605	0.292	-0.269	-0.007	1.000	0.013	-0.352	0.216	0.013	0.019	0.008	0.001	0.076	0.007	0.004	0.005	0.052	0.228	0.019	0.195	0.262	0.019	0.105	0.037	0.140	0.007	0.033	0.041	0.068	0.044	0.010	0.027	0.194	0.004	0.035	0.253
Length2	-0.012	0.118	0.020	0.053	0.053	0.035	-0.058	-0.026	0.053	-0.053	-0.029	0.013	1.000	0.004	0.532	-0.494	-0.005	0.954	0.381	0.023	0.013	1.000	0.004	-0.008	0.030	0.032	0.028	0.005	0.466	0.009	0.009	0.025	0.011	0.013	0.002	0.022	0.020	0.003	0.023	0.009	0.005	0.005	0.010	0.016	0.029	0.034	0.008	0.006	0.009	0.003	0.007	0.008
Pressure2	0.043	-0.112	0.031	-0.029	-0.029	-0.247	-0.101	-0.073	-0.029	0.029	0.270	-0.352	0.004	1.000	-0.132	0.830	-0.942	-0.086	-0.089	-0.009	-0.352	0.004	1.000	-0.285	0.003	0.033	0.003	0.000	0.044	0.000	0.001	0.003	0.013	0.358	0.005	0.014	0.299	0.006	0.087	0.028	0.079	0.002	0.028	0.083	0.055	0.064	0.003	0.034	0.030	0.000	0.008	0.022
TownCount	-0.050	0.245	-0.061	0.043	0.043	0.353	-0.020	-0.085	0.043	-0.043	-0.383	0.216	-0.008	-0.285	0.042	-0.223	0.296	0.060	0.024	0.011	0.216	-0.008	-0.285	1.000	0.045	0.126	0.035	0.002	0.050	0.015	0.012	0.031	0.077	0.056	0.026	0.298	0.148	0.019	0.580	0.446	0.039	0.020	0.126	0.157	0.356	0.331	0.018	0.142	0.816	0.006	0.070	1.000
No_Incidents	0.021	0.018	0.003	0.697	0.626	0.031	0.018	0.020	0.997	0.348	0.038	0.019	0.031	0.005	0.051	0.000	0.034	0.032	0.000	0.026	0.013	0.030	0.003	0.045	1.000	0.009	0.505	0.000	0.087	0.137	0.186	0.451	0.037	0.000	0.030	0.044	0.026	0.002	0.045	0.007	0.002	0.002	0.015	0.010	0.010	0.020	0.014	0.014	0.086	0.002	0.007	0.088
pipe_inspected_frequently	0.141	0.155	0.058	0.011	0.011	0.074	0.403	0.294	0.009	0.008	0.091	0.034	0.045	0.041	0.003	0.000	0.087	0.025	0.002	0.000	0.019	0.032	0.033	0.126	0.009	1.000	0.005	0.001	0.007	0.001	0.001	0.005	0.038	0.027	0.013	0.012	0.036	0.018	0.221	0.028	0.020	0.012	0.024	0.096	0.141	0.001	0.012	0.053	0.105	0.004	0.012	0.082
Incidence	0.027	0.032	0.006	0.572	0.569	0.030	0.031	0.035	0.509	0.457	0.040	0.020	0.029	0.005	0.047	0.000	0.025	0.024	0.000	0.097	0.008	0.028	0.003	0.035	0.505	0.005	1.000	0.000	0.041	0.276	0.374	0.885	0.043	0.000	0.029	0.018	0.014	0.001	0.040	0.002	0.000	0.001	0.007	0.003	0.005	0.010	0.010	0.005	0.038	0.002	0.003	0.034
NumConnectionsUnder	0.007	0.011	0.003	0.000	0.000	0.007	0.004	0.004	0.000	0.000	0.015	0.004	0.005	0.002	0.011	0.000	0.002	0.001	0.000	0.000	0.001	0.005	0.000	0.002	0.000	0.001	0.000	1.000	0.007	0.000	0.000	0.000	0.003	0.003	0.008	0.000	0.001	0.012	0.009	0.003	0.001	0.000	0.000	0.001	0.004	0.004	0.000	0.000	0.002	0.000	0.003	0.001
connection_bool	0.098	0.066	0.011	0.087	0.087	0.106	0.041	0.026	0.087	0.056	0.120	0.092	0.502	0.111	0.518	0.000	0.099	0.290	0.000	0.000	0.076	0.466	0.044	0.050	0.087	0.007	0.041	0.007	1.000	0.011	0.016	0.036	0.028	0.116	0.013	0.001	0.099	0.011	0.078	0.026	0.013	0.008	0.021	0.011	0.046	0.002	0.002	0.017	0.007	0.002	0.001	0.004
Severity_high	0.005	0.004	0.003	0.142	0.208	0.007	0.008	0.010	0.179	0.411	0.010	0.009	0.009	0.002	0.013	0.000	0.015	0.011	0.000	0.000	0.007	0.009	0.000	0.015	0.137	0.001	0.276	0.000	0.011	1.000	0.000	0.000	0.001	0.001	0.003	0.016	0.007	0.001	0.012	0.001	0.000	0.000	0.001	0.002	0.001	0.003	0.000	0.002	0.011	0.000	0.001	0.014
Severity_medium	0.008	0.006	0.003	0.193	0.263	0.014	0.010	0.015	0.241	0.361	0.016	0.007	0.010	0.001	0.016	0.000	0.012	0.009	0.000	0.004	0.004	0.009	0.001	0.012	0.186	0.001	0.374	0.000	0.016	0.000	1.000	0.000	0.002	0.001	0.000	0.013	0.006	0.002	0.014	0.004	0.000	0.000	0.003	0.003	0.009	0.006	0.000	0.004	0.006	0.000	0.001	0.008
Severity_low	0.027	0.033	0.007	0.530	0.551	0.027	0.030	0.032	0.453	0.339	0.037	0.019	0.026	0.004	0.043	0.000	0.019	0.020	0.000	0.108	0.005	0.025	0.003	0.031	0.451	0.005	0.885	0.000	0.036	0.000	0.000	1.000	0.048	0.001	0.031	0.010	0.012	0.000	0.039	0.001	0.000	0.001	0.006	0.001	0.010	0.008	0.012	0.003	0.037	0.002	0.003	0.031
gas_natural	0.291	0.518	0.166	0.116	0.118	0.269	0.116	0.118	0.042	0.073	0.376	0.215	0.013	0.033	0.030	0.000	0.065	0.046	0.003	0.015	0.052	0.011	0.013	0.077	0.037	0.038	0.043	0.003	0.028	0.001	0.002	0.048	1.000	0.023	0.260	0.019	0.031	0.001	0.183	0.008	0.066	0.005	0.010	0.021	0.017	0.037	0.041	0.030	0.015	0.010	0.012	0.035
Material_Acrylonitrile-Butadiene-Styrene	0.042	0.072	0.037	0.002	0.001	0.054	0.029	0.029	0.001	0.004	0.099	0.277	0.015	0.890	0.062	0.002	0.126	0.102	0.002	0.000	0.228	0.013	0.358	0.056	0.000	0.027	0.000	0.003	0.116	0.001	0.001	0.001	0.023	1.000	0.013	0.038	0.837	0.016	0.178	0.025	0.144	0.008	0.038	0.015	0.007	0.007	0.007	0.004	0.042	0.002	0.013	0.025
Material_Copper	0.103	0.158	0.051	0.070	0.070	0.102	0.074	0.061	0.033	0.044	0.138	0.089	0.004	0.012	0.018	0.005	0.024	0.020	0.011	0.028	0.019	0.002	0.005	0.026	0.030	0.013	0.029	0.008	0.013	0.003	0.000	0.031	0.260	0.013	1.000	0.007	0.152	0.003	0.071	0.010	0.003	0.002	0.007	0.028	0.031	0.010	0.058	0.010	0.012	0.002	0.005	0.013
Material_Fiberglass-Reinforced Plastic	0.083	0.063	0.017	0.046	0.049	0.242	0.025	0.046	0.044	0.038	0.273	0.289	0.025	0.035	0.014	0.000	0.439	0.042	0.000	0.000	0.195	0.022	0.014	0.298	0.044	0.012	0.018	0.000	0.001	0.016	0.013	0.010	0.019	0.038	0.007	1.000	0.439	0.008	0.178	0.024	0.009	0.005	0.043	0.038	0.045	0.059	0.004	0.038	0.140	0.001	0.017	0.183
Material_Polyethylene	0.052	0.079	0.032	0.027	0.028	0.108	0.066	0.051	0.026	0.023	0.156	0.351	0.022	0.745	0.047	0.002	0.169	0.102	0.002	0.005	0.262	0.020	0.299	0.148	0.026	0.036	0.014	0.001	0.099	0.007	0.006	0.012	0.031	0.837	0.152	0.439	1.000	0.182	0.191	0.020	0.120	0.010	0.053	0.025	0.018	0.040	0.001	0.009	0.102	0.002	0.020	0.103
Material_Polypropylene	0.164	0.244	0.081	0.008	0.008	0.162	0.177	0.099	0.008	0.011	0.421	0.032	0.006	0.014	0.009	0.000	0.018	0.011	0.000	0.002	0.019	0.003	0.006	0.019	0.002	0.018	0.001	0.012	0.011	0.001	0.002	0.000	0.001	0.016	0.003	0.008	0.182	1.000	0.071	0.056	0.002	0.001	0.008	0.007	0.018	0.016	0.000	0.013	0.011	0.005	0.001	0.012
Province	0.326	0.150	0.046	0.034	0.032	0.133	0.185	0.192	0.030	0.018	0.167	0.155	0.028	0.101	0.023	0.002	0.176	0.037	0.003	0.002	0.105	0.023	0.087	0.580	0.045	0.221	0.040	0.009	0.078	0.012	0.014	0.039	0.183	0.178	0.071	0.178	0.191	0.071	1.000	0.999	1.000	0.103	1.000	1.000	0.992	0.981	0.097	0.999	0.994	0.061	1.000	0.810
Autonomía_Andalucía	0.251	0.082	0.031	0.009	0.009	0.114	0.034	0.099	0.007	0.006	0.131	0.097	0.012	0.031	0.025	0.000	0.066	0.030	0.000	0.002	0.037	0.009	0.028	0.446	0.007	0.028	0.002	0.003	0.026	0.001	0.004	0.001	0.008	0.025	0.010	0.024	0.020	0.056	0.999	1.000	0.021	0.011	0.095	0.083	0.264	0.137	0.010	0.084	0.100	0.003	0.037	0.082
Autonomía_Aragón	0.028	0.090	0.035	0.004	0.005	0.038	0.028	0.038	0.004	0.003	0.085	0.144	0.006	0.179	0.006	0.000	0.032	0.034	0.000	0.000	0.140	0.005	0.079	0.039	0.002	0.020	0.000	0.001	0.013	0.000	0.000	0.000	0.066	0.144	0.003	0.009	0.120	0.002	1.000	0.021	1.000	0.002	0.020	0.018	0.056	0.029	0.002	0.018	0.021	0.000	0.008	0.017
Autonomía_Balears (Illes)	0.028	0.062	0.028	0.002	0.003	0.020	0.041	0.034	0.002	0.000	0.035	0.022	0.008	0.018	0.007	0.000	0.016	0.002	0.000	0.000	0.007	0.005	0.002	0.020	0.002	0.012	0.001	0.000	0.008	0.000	0.000	0.001	0.005	0.008	0.002	0.005	0.010	0.001	0.103	0.011	0.002	1.000	0.011	0.009	0.029	0.015	0.001	0.009	0.011	0.000	0.004	0.009
Autonomía_Castilla y León	0.439	0.114	0.014	0.015	0.015	0.039	0.097	0.063	0.015	0.010	0.052	0.202	0.018	0.035	0.017	0.000	0.144	0.035	0.002	0.001	0.033	0.010	0.028	0.126	0.015	0.024	0.007	0.000	0.021	0.001	0.003	0.006	0.010	0.038	0.007	0.043	0.053	0.008	1.000	0.095	0.020	0.011	1.000	0.081	0.257	0.133	0.010	0.082	0.097	0.003	0.036	0.079
Autonomía_Castilla-La Mancha	0.332	0.130	0.021	0.013	0.013	0.113	0.272	0.213	0.009	0.007	0.124	0.099	0.016	0.084	0.007	0.000	0.129	0.025	0.002	0.000	0.041	0.016	0.083	0.157	0.010	0.096	0.003	0.001	0.011	0.002	0.003	0.001	0.021	0.015	0.028	0.038	0.025	0.007	1.000	0.083	0.018	0.009	0.081	1.000	0.225	0.117	0.008	0.072	0.085	0.003	0.032	0.070
Autonomía_Cataluña	0.540	0.170	0.032	0.012	0.016	0.232	0.321	0.267	0.011	0.005	0.252	0.103	0.031	0.059	0.042	0.001	0.229	0.024	0.001	0.002	0.068	0.029	0.055	0.356	0.010	0.141	0.005	0.004	0.046	0.001	0.009	0.010	0.017	0.007	0.031	0.045	0.018	0.018	0.992	0.264	0.056	0.029	0.257	0.225	1.000	0.371	0.027	0.228	0.271	0.009	0.101	0.221
Autonomía_Comunidad Valenciana	0.175	0.107	0.022	0.020	0.020	0.145	0.006	0.087	0.020	0.016	0.165	0.173	0.042	0.069	0.021	0.000	0.134	0.039	0.000	0.000	0.044	0.034	0.064	0.331	0.020	0.001	0.010	0.004	0.002	0.003	0.006	0.008	0.037	0.007	0.010	0.059	0.040	0.016	0.981	0.137	0.029	0.015	0.133	0.117	0.371	1.000	0.014	0.118	0.141	0.005	0.052	0.115
Autonomía_Extremadura	0.070	0.068	0.036	0.041	0.039	0.071	0.116	0.066	0.014	0.011	0.107	0.034	0.011	0.008	0.008	0.000	0.015	0.006	0.000	0.008	0.010	0.008	0.003	0.018	0.014	0.012	0.010	0.000	0.002	0.000	0.000	0.012	0.041	0.007	0.058	0.004	0.001	0.000	0.097	0.010	0.002	0.001	0.010	0.008	0.027	0.014	1.000	0.008	0.010	0.000	0.004	0.008
Autonomía_Galicia	0.326	0.097	0.042	0.018	0.018	0.111	0.061	0.093	0.014	0.006	0.134	0.045	0.013	0.045	0.013	0.000	0.130	0.011	0.002	0.001	0.027	0.006	0.034	0.142	0.014	0.053	0.005	0.000	0.017	0.002	0.004	0.003	0.030	0.004	0.010	0.038	0.009	0.013	0.999	0.084	0.018	0.009	0.082	0.072	0.228	0.118	0.008	1.000	0.086	0.003	0.032	0.070
Autonomía_Madrid (Comunidad de)	0.333	0.266	0.017	0.088	0.089	0.160	0.386	0.450	0.086	0.044	0.208	0.231	0.010	0.050	0.007	0.000	0.324	0.061	0.000	0.003	0.194	0.009	0.030	0.816	0.086	0.105	0.038	0.002	0.007	0.011	0.006	0.037	0.015	0.042	0.012	0.140	0.102	0.011	0.994	0.100	0.021	0.011	0.097	0.085	0.271	0.141	0.010	0.086	1.000	0.003	0.038	0.814
Autonomía_Navarra (Comunidad Foral de)	0.019	0.043	0.017	0.007	0.007	0.026	0.067	0.052	0.004	0.004	0.031	0.011	0.003	0.003	0.000	0.000	0.005	0.003	0.000	0.000	0.004	0.003	0.000	0.006	0.002	0.004	0.002	0.000	0.002	0.000	0.000	0.002	0.010	0.002	0.002	0.001	0.002	0.005	0.061	0.003	0.000	0.000	0.003	0.003	0.009	0.005	0.000	0.003	0.003	1.000	0.001	0.003
Autonomía_Rioja (La)	0.185	0.047	0.031	0.007	0.007	0.013	0.052	0.058	0.007	0.005	0.026	0.054	0.012	0.046	0.004	0.000	0.058	0.015	0.000	0.000	0.035	0.007	0.008	0.070	0.007	0.012	0.003	0.003	0.001	0.001	0.001	0.003	0.012	0.013	0.005	0.017	0.020	0.001	1.000	0.037	0.008	0.004	0.036	0.032	0.101	0.052	0.004	0.032	0.038	0.001	1.000	0.031
Madrid	0.272	0.260	0.022	0.093	0.095	0.189	0.315	0.373	0.089	0.037	0.244	0.282	0.008	0.053	0.008	0.000	0.421	0.084	0.000	0.000	0.253	0.008	0.022	1.000	0.088	0.082	0.034	0.001	0.004	0.014	0.008	0.031	0.035	0.025	0.013	0.183	0.103	0.012	0.810	0.082	0.017	0.009	0.079	0.070	0.221	0.115	0.008	0.070	0.814	0.003	0.031	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	PipeId	No_Inspections	InspectionYear	Age_pipe_at_inspection	pipe_inspected_frequently	Average_MonthsLastRev	MonthsLastRev	average_severity_pipe	YearBuilt	Diameter	Length	Pressure	aspect	Relative_Thickness	pipe_area	gas_natural	Material_Polyethylene	Diameter2	Length2	Pressure2	Province	Town	TownCount	Autonomía_Castilla-La Mancha
0	489616	5	2013.00	1.00	1	21.40	16.00	4.00	2012	0.06	7.79	0.40	0.81	0.16	1.54	1	1	0.00	60.72	0.16	ciudad real	torralba de calatrava	2093	1
1	489616	5	2015.00	3.00	1	21.40	22.00	4.00	2012	0.06	7.79	0.40	0.81	0.16	1.54	1	1	0.00	60.72	0.16	ciudad real	torralba de calatrava	2093	1
2	489616	5	2016.00	4.00	1	21.40	22.00	4.00	2012	0.06	7.79	0.40	0.81	0.16	1.54	1	1	0.00	60.72	0.16	ciudad real	torralba de calatrava	2093	1
3	489616	5	2018.00	6.00	1	21.40	23.00	4.00	2012	0.06	7.79	0.40	0.81	0.16	1.54	1	1	0.00	60.72	0.16	ciudad real	torralba de calatrava	2093	1
4	489616	5	2020.00	8.00	1	21.40	24.00	4.00	2012	0.06	7.79	0.40	0.81	0.16	1.54	1	1	0.00	60.72	0.16	ciudad real	torralba de calatrava	2093	1
5	489645	5	2013.00	1.00	1	21.40	16.00	4.00	2012	0.09	2.08	0.40	2.14	0.22	0.59	1	1	0.01	4.33	0.16	ciudad real	torralba de calatrava	2093	1
6	489645	5	2015.00	3.00	1	21.40	22.00	4.00	2012	0.09	2.08	0.40	2.14	0.22	0.59	1	1	0.01	4.33	0.16	ciudad real	torralba de calatrava	2093	1
7	489645	5	2016.00	4.00	1	21.40	22.00	4.00	2012	0.09	2.08	0.40	2.14	0.22	0.59	1	1	0.01	4.33	0.16	ciudad real	torralba de calatrava	2093	1
8	489645	5	2018.00	6.00	1	21.40	23.00	4.00	2012	0.09	2.08	0.40	2.14	0.22	0.59	1	1	0.01	4.33	0.16	ciudad real	torralba de calatrava	2093	1
9	489645	5	2020.00	8.00	1	21.40	24.00	4.00	2012	0.09	2.08	0.40	2.14	0.22	0.59	1	1	0.01	4.33	0.16	ciudad real	torralba de calatrava	2093	1

	PipeId	No_Inspections	InspectionYear	Age_pipe_at_inspection	pipe_inspected_frequently	Average_MonthsLastRev	MonthsLastRev	average_severity_pipe	YearBuilt	Diameter	Length	Pressure	aspect	pipe_area	gas_natural	Material_Acrylonitrile-Butadiene-Styrene	Diameter2	Length2	Pressure2	Province	Town	TownCount	Autonomía_Comunidad Valenciana	Autonomía_Rioja (La)
5527744	415704708	1	2012.00	1.00	1	18.00	18.00	4.00	2011	0.15	0.75	49.50	433.07	0.36	1	1	0.02	0.56	2450.25	alicante	finestrat	578	1	0
5527745	416535944	1	2013.00	2.00	1	0.00	0.00	4.00	2011	0.10	1.00	45.00	442.91	0.32	1	1	0.01	1.00	2025.00	la rioja	banos de rio tobia	852	0	1
5527746	416535988	1	2013.00	2.00	1	0.00	0.00	4.00	2011	0.10	0.54	45.00	818.69	0.17	1	1	0.01	0.29	2025.00	la rioja	banos de rio tobia	852	0	1
5527747	416536032	1	2013.00	2.00	1	0.00	0.00	4.00	2011	0.10	0.75	45.00	590.55	0.24	1	1	0.01	0.56	2025.00	la rioja	banos de rio tobia	852	0	1
5527748	416536057	1	2013.00	2.00	1	0.00	0.00	4.00	2011	0.10	0.52	45.00	858.36	0.16	1	1	0.01	0.27	2025.00	la rioja	banos de rio tobia	852	0	1
5527749	416536087	1	2013.00	2.00	1	0.00	0.00	4.00	2011	0.05	0.45	45.00	1951.16	0.07	1	1	0.00	0.21	2025.00	la rioja	banos de rio tobia	852	0	1
5527750	416536416	1	2013.00	2.00	1	0.00	0.00	4.00	2011	0.10	0.48	45.00	926.60	0.15	1	1	0.01	0.23	2025.00	la rioja	banos de rio tobia	852	0	1
5527751	416536438	1	2013.00	2.00	1	0.00	0.00	4.00	2011	0.10	0.48	45.00	913.22	0.15	1	1	0.01	0.24	2025.00	la rioja	banos de rio tobia	852	0	1
5527752	416536460	1	2013.00	2.00	1	0.00	0.00	4.00	2011	0.05	0.21	45.00	4218.22	0.03	1	1	0.00	0.04	2025.00	la rioja	banos de rio tobia	852	0	1
5527753	416536482	1	2013.00	2.00	1	0.00	0.00	4.00	2011	0.05	0.80	45.00	1114.25	0.13	1	1	0.00	0.63	2025.00	la rioja	banos de rio tobia	852	0	1

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks